Stored Procedures [dbo].[BAEGetConfigurationVariable]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@pVariablevarchar(256)256
SQL Script
create procedure [dbo].[BAEGetConfigurationVariable] @pVariable as
varchar(256)
AS
    SELECT *
    FROM Configuration
    WHERE UPPER(Configuration.Variable) = UPPER(@pVariable);

GO
Uses